CREATE TABLE [dbo].[spclz]
(
[iK_spclz] [int] NOT NULL IDENTITY(1, 1),
[cName_spclz] [varchar] (150) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Csh_spclz] [varchar] (10) COLLATE Cyrillic_General_CI_AS NULL,
[cName_spclz_short] [varchar] (20) COLLATE Cyrillic_General_CI_AS NULL,
[ik_spec] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[spclz] ADD CONSTRAINT [PK_spclz] PRIMARY KEY CLUSTERED  ([iK_spclz]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[spclz] ADD CONSTRAINT [IX_spclz] UNIQUE NONCLUSTERED  ([ik_spec], [cName_spclz]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[spclz] ADD CONSTRAINT [IX_spclz_short] UNIQUE NONCLUSTERED  ([ik_spec], [cName_spclz_short]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[spclz] WITH NOCHECK ADD CONSTRAINT [FK_spclz_Spec_stud] FOREIGN KEY ([ik_spec]) REFERENCES [dbo].[Spec_stud] ([ik_spec])
GO
